Let's take a look at one more option in regards to printing.
Now in many cases when you go to a printed document you're going to print the entire thing.
The spreadsheet all of its data the charts the entire set of data contained within that worksheet.
But there will come a time where you want to print just a specific portion of the document.
Like I only want to print the little spreadsheet right here my bills the months their totals their percentage
.
That's it.
Well right now if I go file the print I print out the entire thing well inside of Excel.
We have what's called the print area.
You set a print area you literally Slyke the cells that you want to print.
You go to a two page layout print area set the print area and that's all you'll print when you go to
File Print.
So take a look.
So I only want to put this little spreadsheet.
No title no min max average count.
No chart.
That's it.
So I'm going to select my little spreadsheet.
That's A-3 down to F 9.
There we go.
I'm going to go up to page layout.
I'm going to go to a print area and I'm going to set the print area so I'm going to look away from my
little spreadsheet there and you probably just barely see it on the screen.
But probably best see it down here in the corner.
There's a little bit of a darker border that actually goes all the way around my spreadsheet.
And that's just denoting that this is the print area.
So now I'm going to file to print and see that I'm only printing out a little spreadsheet.
No title no min max average account no chart.
It's just the spreadsheet set your print area.
Now what if you want to get back to the entire spreadsheet you want to print everything.
Well you set the print Geria You can also clear it.
You can get rid of the print area.
What's this hit my doc will take me back to excel.
I'm going to go to page layouts back to print area where I said it earlier and now are clear it's clear
the print area.
And if I go back to file back to print I'm now printing the entire worksheet once again all two pages
of it is two pages.
Now we saw by accident earlier.
If you select a chart and you go file print you print just that chart kind of like setting the print
area but you're just selecting the charts so you only get that ID fault.
So try this out.
Set your own print area.
Maybe you just want a specific month or couple of months or specific bills or maybe you just want the
charts like the chart print that select your data set the print Geria print that.
Don't forget to go back and clear it though when you're all done.
You printed what you wanted go clear the print Geria you'll be back to square one again.
Try it out